Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL SETAREATOSSLIMIT qualifier

Set the toss limit for the specified area.

Syntax

proutil db-name -C setareatosslimit area-number toss-limit

Parameters

db-name

Specifies the database where you are setting the toss limit.

area-number

Specifies the area where you are setting the toss limit.

toss-limit

Specifies the new toss limit. The toss limit is the minimum amount of free space that must exist in a block for the block to remain on the free chain as a candidate for holding additional records.

Notes

SETAREATOSSLIMIT will set the limit for all tables and BLOBs in the specified area.
The toss limit value must be greater than 0 and less than the block size minus 128 bytes.
For databases with a 1K block size, the default toss limit is 150. For all other database block sizes, the default toss limit is 300.
The database must be offline when setting toss limits.
For more information on setting toss limits, see the "Database fragmentation" section.